﻿CREATE TABLE [dbo].[JobDetail] (
    [JobId]          UNIQUEIDENTIFIER NOT NULL,
    [JobAttributeId] INT              NOT NULL,
    [RangeFrom]      INT              NULL,
    [RangeTo]        INT              NULL,
    CONSTRAINT [PK_JobDetail] PRIMARY KEY CLUSTERED ([JobId] ASC, [JobAttributeId] ASC),
    CONSTRAINT [FK_JobDetail_Job] FOREIGN KEY ([JobId]) REFERENCES [dbo].[Job] ([JobId]),
    CONSTRAINT [FK_JobDetail_JobAttribute] FOREIGN KEY ([JobAttributeId]) REFERENCES [dbo].[JobAttribute] ([JobAttributeId])
);



